Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RewardDerivationRuleEligibilityID (PK) | A unique identifier for a Reward Derivation Rule Eligibility. | ID_EL_PRDV | Identity | integer | |
RewardEligibilitySequenceNumber (AK) | Specifies the relative execution order for the eligibility rule tied to a Reward. | AI_RWD_EL_SQN_NMB | LineNumber | smallint | |
RewardID (AK)(FK) | A token identifier for a Reward instance. | ID_RWD | Identity | integer | Reward(TR_RWD) |
RewardEligibilityPropertyTypeCode (FK) | A short code used to identify a valid RewardEligibilityPropertyType. Valid values are: BRAND_NAME Brand ARTS ODM V7.2 CALENDAR_ID Calendar Period part 1 ARTS ODM V7.2 CALENDAR_LEVEL_ID Calendar Period part 2 ARTS ODM V7.2 CALENDAR_PERIOD_ID Calendar Period part 3 ARTS ODM V7.2 CHANNEL_ID Channel ARTS ODM V7.2 CUSTOMER_ACCOUNT_ID Customer Account ARTS ODM V7.2 CUSTOMER_MEMBER_PROGRAM_ACCOUNT_ID Customer Membershipp Prog Acct ARTS ODM V7.2 EMPLOYEE_DISCOUNT_GROUP_ID Employee Discount Group ARTS ODM V7.2 ITEM_ID Single Item ID (SKU) ARTS ODM V7.2 MANUFACTURER_ID Manufacturer ARTS ODM V7.2 MARKET_BASKET_TRIGGER_ID (follow up on this one) ARTS ODM V7.2 MERCHANDISE_HIERARCHY_GROUP Merch Hier. Group (we're simplifying this will require tree view to create UI) ARTS ODM V7.2 PRICE_LINE_ID Price Line ARTS ODM V7.2 PRICE_OVERRIDE Flagged overriden price - no ARTS equivalent SALE_RTN_CLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_DEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_ITEM_CLEARANCE no ARTS equivalent SALE_RTN_ITEM_DISCOUNTED Sale Return item is already discounted SALE_RTN_ITEM_STOCK_STATUS no ARTS equivalent SALE_RTN_ITEM_VENDOR This should be handled by mfg / brand SALE_RTN_QUANTITY Eligibilty trigger qty SALE_RTN_SKU Handled by ITEM_ID SALE_RTN_STYLE This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBCLASS This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_SUBDEPARTMENT This should be handled in MERCHANDISE HIERARCHY GROUP SALE_RTN_UNIT_PRICE Eligibilty trigger retail price SEASON see Calendar SEQ_NUMBER Comparison is between the line item number from sale return row and the value in VALUE1 TENDER_MEDIA_BRAND_ID Branded Tender Type part 2 ARTS ODM V7.2 TENDER_TYPE_CODE Branded Tender Type part 1 ARTS ODM V7.2 | CD_RWD_EL_PRY_TYP_CD | Code | varchar(20) | RewardEligibilityPropertyType(CO_RWD_EL_PRY_TYP) |
EligibilityVerbTypeCode | A controlled vocabulary attribute used to standardize the representation of customer actions that must be taken to trigger a RewardDerivationRule. Valid Values: BUY RENT TRADEIN IS_A (customer is a GOLD) RETURN Others may be added by the retailer. | CD_EL_VRB_TYP | Code | varchar(20) | |
CompareCode | A code that indicates the kind of comparison excuted to determine if an eligibility condition applies to a specific retail transaction and/or a sale return line item's property type. Valid values are: EQ equals NE not equal GT greater than GE greater than or equal to LT less than LE less than or equal to IN value is GE and LE value1 and value 2 | CD_CMPR | Code2 | char(2) | |
EligibilityPropertyValueDataTypeCode | Indicates whether the value is a string, a date, a monetary value, or a quantity. | CD_EL_PRY_VL_DAT_TYP | Code | varchar(20) | |